/**
 * 
 */
package com.demo2do.fms.scheduler.dao.epp;

import java.util.List;

import com.demo2do.core.persistence.annotation.Dao;
import com.demo2do.core.persistence.annotation.Query;
import com.demo2do.fms.scheduler.entity.Branch;
import com.demo2do.fms.scheduler.entity.Vendor;

/**
 * @author Ysy
 *
 */
@Dao
public interface EppDao {

    /**
     * 
     * @return
     */
    @Query("SELECT sid as id, sname as name, scode as code, version as version, sValidState as state FROM v_Ogns")
    public List<Branch> listEppBranch();
    
    /**
     * 
     * @return
     */
    @Query("SELECT fID as id, fCode as code, fName as name, fShortName as short_name, fCertifStatus as status, fDeposit as deposit, fPayDays as account_playable_days, "
             + "fBusinessScope as scope, fBank as bank_name, fAccountNo as bank_account, fTaxNo as tax_number, fLegal as legal_person, fAddress as address, fZipCode as zip_code, "
             + "fTelNo as mobile, fFaxNo as fax, fContact1 as main_contactor, fContact2 as second_contactor, fContactMobile1 as main_phone, fContactMobile2 as second_phone, "
             + "fContactEmail1 as main_email, fContactEmail2 as second_email, fNote as remark, fOgnID as branch_id, version, fAttachment as attachment "
         + "FROM v_GeneralSuppliers")
    public List<Vendor> listEppVendor();
    
}
